﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Printstudent.aspx.cs" Inherits="ybqy_print_fengmian" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<link href="../../StyleSheet.css" rel="stylesheet" type="text/css" />

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
        <style type="text/css">
        table tr
        {
            border: 1px solid;
            padding: 5px 15px 5px 5px;
            height: 15px;
        }
        table td
        {
            border: 1px solid ;
            padding: 5px 15px 5px 5px;
            vertical-align: middle;
        }
                   
    </style>

</head>

<body>
    <form id="form1" runat="server">
<div>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    <asp:Label ID="Label1" runat="server"></asp:Label></div><br />
<div>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        >
        <Columns>
            <asp:BoundField DataField="bumenmingcheng" HeaderText="部门名称" 
                SortExpression="bumenmingcheng">
            <HeaderStyle Width="200px" />
            <ItemStyle Width="200px" />
            </asp:BoundField>
            <asp:BoundField DataField="Name" HeaderText="名字" SortExpression="Name">
            <HeaderStyle Width="100px" />
            <ItemStyle Width="100px" />
            </asp:BoundField>
            <asp:BoundField DataField="kaoshenghao" HeaderText="考生号" 
                SortExpression="kaoshenghao">
            <HeaderStyle Width="80px" />
            <ItemStyle Width="80px" />
            </asp:BoundField>
            <asp:BoundField DataField="peixunpici" HeaderText="学习批次" 
                SortExpression="peixunpici">
            <HeaderStyle Width="200px" />
            <ItemStyle Width="200px" />
            </asp:BoundField>
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" SelectCommand="SELECT Student.ID, Student.Name, Student.kaoshenghao,Student.peixunpici,danwei.danweimingchen, 
      bumeng.bumenmingcheng
FROM Student,danwei,bumeng 
where danwei.id = bumeng.id and danwei.id = Student.ID"></asp:SqlDataSource>
</div>
    </form>
    </body>
</html>
